﻿
---------------------------------------------
-- Championship Ligue 1 2011-2012
---------------------------------------------

INSERT INTO [ParieurProDB].[dbo].[Championships]
           ([ChampionshipId]
           ,[Name]
           ,[Icon])
     VALUES
           (1
           ,'Ligue 1'
           ,NULL);
GO

INSERT INTO [ParieurProDB].[dbo].[Seasons]
           ([StartYear]
           ,[EndYear]
           ,[Display])
     VALUES
           (2011
           ,2012
           ,'2011-2012');
GO

INSERT INTO [ParieurProDB].[dbo].[Contests]
           ([ChampionshipId]
           ,[SeasonId], [IsClosed])
     VALUES
           (1
           ,1
		   , False);
GO

INSERT INTO [ParieurProDB].[dbo].[CustomContest]
           ([AdministratorId]
           ,[DisplayName]
           ,[Password])
     VALUES
           ('AD9933C0-A728-4A2C-AC38-76D65D58AA4A'
           ,'Ligue 1 (2011-2012)'
           ,NULL);
GO


INSERT INTO [ParieurProDB].[dbo].[CustomContestLinks]
           ([ContestId]
           ,[CustomContestId])
     VALUES
           (1, 1);
GO

----------------------------------------
-- Teams
----------------------------------------

INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('AC Ajaccio'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Toulouse FC'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('AS Nancy Lorraine'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('LOSC Lille Métropole'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Girondins de Bordeaux'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('AS Saint-Etienne'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Stade Brestois 29'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Evian TG FC'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('SM Caen'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Valenciennes FC'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Dijon FCO'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Stade Rennais FC'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Olympique de Marseille'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('FC Sochaux Montbeliard'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Montpellier Hérault SC'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('AJ Auxerre'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('OGC Nice'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Olympique Lyonnais'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('Paris Saint-Germain'
           ,NULL);
GO
INSERT INTO [ParieurProDB].[dbo].[Teams]
           ([Name]
           ,[Icon])
     VALUES
           ('FC Lorient'
           ,NULL);
GO



